ALTER VIEW [dbo].[View_FW_Application2Module]
AS
SELECT
         fam.Application2ModuleGUID,
         fam.ApplicationGUID,
         fam.ModuleGUID,
         fam.A2MOrderCode,
         fam.TenantId,
         fam.IsDeleted,
         fam.CreateTime,
         fam.CreateGUID,
         fam.CreatedName,
         fam.ModifiedTime,
         fam.ModifiedGUID,
         fam.ModifiedName,
         fam.ApproveState,
         fam.ApproveGUID,
         fam.ApproveTime,
         fam.BuUnitGUID,

		 fm.ModuleName,
		 fm.ModuleCode,
		 fm.ModuleIconCls,
		 fm.ModuleUrl,
		 fm.ModuleHelpUrl,
		 fm.ModuleIsDisable,
		 fm.IsFullModule,

		 fa.ApplicationName,
		 fa.ApplicationCode,
		 fa.ApplicationIconCls,
		 fa.ApplicationIsDisable
FROM dbo.FW_Application2Module  fam
LEFT JOIN dbo.FW_Application fa ON fam.ApplicationGUID=fa.ApplicationGUID
LEFT JOIN dbo.FW_Module fm ON fm.ModuleGUID=fam.ModuleGUID